<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_store_shipping_region`;");
E_C("CREATE TABLE `ecs_store_shipping_region` (
  `rec_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` smallint(5) unsigned NOT NULL,
  `province` smallint(5) unsigned NOT NULL DEFAULT '0',
  `city` smallint(5) unsigned NOT NULL DEFAULT '0',
  `district` smallint(5) unsigned NOT NULL DEFAULT '0',
  `xiangcun` smallint(5) unsigned NOT NULL DEFAULT '0',
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '入驻商店铺id',
  `store_type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '仓库类型id',
  PRIMARY KEY (`rec_id`),
  KEY `province_id` (`province`,`city`,`district`),
  KEY `supplier_id` (`supplier_id`)
) ENGINE=MyISAM AUTO_INCREMENT=114 DEFAULT CHARSET=utf8 COMMENT='仓库派送区域'");
E_D("replace into `ecs_store_shipping_region` values('1','2','3428','3431','3439','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('2','2','3428','3431','3440','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('3','1','2','52','500','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('4','1','2','52','500','3426','0','0');");
E_D("replace into `ecs_store_shipping_region` values('5','1','2','52','500','3425','0','0');");
E_D("replace into `ecs_store_shipping_region` values('6','1','2','52','500','3427','0','0');");
E_D("replace into `ecs_store_shipping_region` values('7','1','2','52','502','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('8','1','2','52','502','3421','0','0');");
E_D("replace into `ecs_store_shipping_region` values('9','1','2','52','502','3424','0','0');");
E_D("replace into `ecs_store_shipping_region` values('10','1','2','52','502','3423','0','0');");
E_D("replace into `ecs_store_shipping_region` values('11','1','2','52','502','3422','0','0');");
E_D("replace into `ecs_store_shipping_region` values('12','1','10','138','1078','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('13','1','10','138','1079','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('14','1','10','138','1080','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('15','1','10','138','1081','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('16','1','10','138','1082','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('17','1','10','138','1083','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('18','1','10','138','1084','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('19','1','10','138','1085','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('20','1','10','138','1086','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('21','1','10','138','1087','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('22','1','10','138','1088','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('23','1','10','138','1089','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('24','1','10','138','1090','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('25','1','10','138','1091','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('26','1','10','138','1092','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('27','1','10','138','1093','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('28','1','10','138','1094','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('29','1','10','138','1095','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('30','1','10','138','1097','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('31','1','10','138','1098','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('32','1','10','145','1194','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('33','1','10','145','1194','3411','0','0');");
E_D("replace into `ecs_store_shipping_region` values('34','1','10','145','1194','3410','0','0');");
E_D("replace into `ecs_store_shipping_region` values('35','1','10','145','1194','3409','0','0');");
E_D("replace into `ecs_store_shipping_region` values('36','1','10','145','1195','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('37','1','10','145','1195','3420','0','0');");
E_D("replace into `ecs_store_shipping_region` values('38','1','10','145','1195','3419','0','0');");
E_D("replace into `ecs_store_shipping_region` values('39','1','10','145','1195','3418','0','0');");
E_D("replace into `ecs_store_shipping_region` values('40','1','10','145','1195','3417','0','0');");
E_D("replace into `ecs_store_shipping_region` values('41','1','10','145','1196','0','0','0');");
E_D("replace into `ecs_store_shipping_region` values('42','1','10','145','1196','3416','0','0');");
E_D("replace into `ecs_store_shipping_region` values('43','1','10','145','1196','3415','0','0');");
E_D("replace into `ecs_store_shipping_region` values('44','1','10','145','1196','3414','0','0');");
E_D("replace into `ecs_store_shipping_region` values('45','1','10','145','1196','3413','0','0');");
E_D("replace into `ecs_store_shipping_region` values('46','1','10','145','1196','3412','0','0');");
E_D("replace into `ecs_store_shipping_region` values('47','0','10','145','1194','0','18','18');");
E_D("replace into `ecs_store_shipping_region` values('48','0','10','145','1194','3411','18','18');");
E_D("replace into `ecs_store_shipping_region` values('49','0','10','145','1194','3410','18','18');");
E_D("replace into `ecs_store_shipping_region` values('50','0','10','145','1194','3409','18','18');");
E_D("replace into `ecs_store_shipping_region` values('51','0','10','145','1195','0','18','18');");
E_D("replace into `ecs_store_shipping_region` values('52','0','10','145','1195','3420','18','18');");
E_D("replace into `ecs_store_shipping_region` values('53','0','10','145','1195','3419','18','18');");
E_D("replace into `ecs_store_shipping_region` values('54','0','10','145','1195','3418','18','18');");
E_D("replace into `ecs_store_shipping_region` values('55','0','10','145','1195','3417','18','18');");
E_D("replace into `ecs_store_shipping_region` values('56','0','10','145','1196','0','18','18');");
E_D("replace into `ecs_store_shipping_region` values('57','0','10','145','1196','3416','18','18');");
E_D("replace into `ecs_store_shipping_region` values('58','0','10','145','1196','3415','18','18');");
E_D("replace into `ecs_store_shipping_region` values('59','0','10','145','1196','3414','18','18');");
E_D("replace into `ecs_store_shipping_region` values('60','0','10','145','1196','3413','18','18');");
E_D("replace into `ecs_store_shipping_region` values('61','0','10','145','1196','3412','18','18');");
E_D("replace into `ecs_store_shipping_region` values('62','5','10','145','1194','0','18','18');");
E_D("replace into `ecs_store_shipping_region` values('63','5','10','145','1194','3411','18','18');");
E_D("replace into `ecs_store_shipping_region` values('64','5','10','145','1194','3410','18','18');");
E_D("replace into `ecs_store_shipping_region` values('65','5','10','145','1194','3409','18','18');");
E_D("replace into `ecs_store_shipping_region` values('66','7','10','145','1194','0','18','18');");
E_D("replace into `ecs_store_shipping_region` values('67','7','10','145','1194','3411','18','18');");
E_D("replace into `ecs_store_shipping_region` values('68','7','10','145','1194','3410','18','18');");
E_D("replace into `ecs_store_shipping_region` values('69','7','10','145','1194','3409','18','18');");
E_D("replace into `ecs_store_shipping_region` values('70','10','2','52','500','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('71','10','2','52','500','3426','22','22');");
E_D("replace into `ecs_store_shipping_region` values('72','10','2','52','500','3425','22','22');");
E_D("replace into `ecs_store_shipping_region` values('73','10','2','52','500','3427','22','22');");
E_D("replace into `ecs_store_shipping_region` values('74','10','2','52','502','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('75','10','2','52','502','3421','22','22');");
E_D("replace into `ecs_store_shipping_region` values('76','10','2','52','502','3424','22','22');");
E_D("replace into `ecs_store_shipping_region` values('77','10','2','52','502','3423','22','22');");
E_D("replace into `ecs_store_shipping_region` values('78','10','2','52','502','3422','22','22');");
E_D("replace into `ecs_store_shipping_region` values('79','9','10','138','1078','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('80','9','10','138','1079','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('81','9','10','138','1080','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('82','9','10','138','1081','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('83','9','10','138','1082','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('84','9','10','138','1083','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('85','9','10','138','1084','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('86','9','10','138','1085','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('87','9','10','138','1086','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('88','9','10','138','1087','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('89','9','10','138','1088','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('90','9','10','138','1089','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('91','9','10','138','1090','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('92','9','10','138','1091','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('93','9','10','138','1092','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('94','9','10','138','1093','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('95','9','10','138','1094','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('96','9','10','138','1095','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('97','9','10','138','1097','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('98','9','10','138','1098','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('99','9','10','145','1194','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('100','9','10','145','1194','3411','22','22');");
E_D("replace into `ecs_store_shipping_region` values('101','9','10','145','1194','3410','22','22');");
E_D("replace into `ecs_store_shipping_region` values('102','9','10','145','1194','3409','22','22');");
E_D("replace into `ecs_store_shipping_region` values('103','9','10','145','1195','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('104','9','10','145','1195','3420','22','22');");
E_D("replace into `ecs_store_shipping_region` values('105','9','10','145','1195','3419','22','22');");
E_D("replace into `ecs_store_shipping_region` values('106','9','10','145','1195','3418','22','22');");
E_D("replace into `ecs_store_shipping_region` values('107','9','10','145','1195','3417','22','22');");
E_D("replace into `ecs_store_shipping_region` values('108','9','10','145','1196','0','22','22');");
E_D("replace into `ecs_store_shipping_region` values('109','9','10','145','1196','3416','22','22');");
E_D("replace into `ecs_store_shipping_region` values('110','9','10','145','1196','3415','22','22');");
E_D("replace into `ecs_store_shipping_region` values('111','9','10','145','1196','3414','22','22');");
E_D("replace into `ecs_store_shipping_region` values('112','9','10','145','1196','3413','22','22');");
E_D("replace into `ecs_store_shipping_region` values('113','9','10','145','1196','3412','22','22');");

require("../../inc/footer.php");
?>